-- ================================START====================================
-- Template generated from		FRAMEWORKIVY CODE GENERATOR
-- Generator Version:			<1.0.0.0>
-- Template Creation Time:		<Sunday, 3 July, 2016   1:56:48 AM>
-- Template Modification Time:	<Sunday, 3 July, 2016   2:02:27 AM>
-- Code Generation Time:		<Wednesday, 6 July, 2016   1:35:18 PM>
-- Workstation ID:				<PRAVESH>
-- Current system User ID:		<pravesh>
-- Entity/Table Name:			<ProjectMemberMaster>
-- Description:					<SQL Server Stored Procedure For Get All>
-- Template File:				<IvyGodeGenDefaultTemplate V1.1.xml>

-- Please modify the generated code as per requirement.
-- This code generator is just to speed up the stereo type codes
-- Complex logic needs to be modified manually.

-- This block of comments will not be included in
-- the definition of the procedure.
-- =========================================================================
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'Ivy_UserManagement_ProjectMemberMaster_GetAll')
	BEGIN
		DROP  Procedure  [Ivy_UserManagement_ProjectMemberMaster_GetAll]
	END
GO

CREATE PROCEDURE [Ivy_UserManagement_ProjectMemberMaster_GetAll]
-- =========================================================================
-- Created by				FRAMEWORKIVY CODE GENERATOR
-- Generator Version:		<1.0.0.0>
-- Template version used:   <1.0>
-- Template created by:		<Mrinmoy Das>
-- Code generated by:		<pravesh>
-- Code generation Time:	<Wednesday, 6 July, 2016   1:35:18 PM>
-- Entity/Table Name:		<ProjectMemberMaster>
-- Description:             <SQL Server Stored Procedure For Get All>
-- =========================================================================

-- Add the parameters for the stored procedure here

	(
			@Sys_IsDeleted int = NULL, 
			@Sys_OrganizationID int = NULL 
	) 
AS 
BEGIN 
	-- SET NOCOUNT ON added to prevent extra result sets from interfering with SELECT statements. 
	SET NOCOUNT ON; 

    SELECT 
			[ProjectMemberKey], 
			[ProjectMemberUserKey], 
			[ProjectMemberFirstName], 
			[ProjectMemberLastName], 
			[ProjectMemberPrimaryEmailID], 
			[ProjectMemberCodePlexID], 
			[ProjectMemberSkypeID], 
			[ProjectMemberMicrosoftID], 
			[ProjectMemberGoogleID], 
			[ProjectMemberTimeZoneReference], 
			[ProjectMemberTimeZoneName], 
			[ProjectMemberTimeZoneAbbreviation], 
			[ProjectMemberCountryName], 
			[ProjectMemberCityName], 
			[ProjectMemberDateOfJoining], 
			[ProjectMemberIsMemberOfFacebook], 

			[Sys_DateOfCreation], 
			[Sys_DateOfModification], 
			[Sys_CreatedByID], 
			[Sys_ModifiedByID], 
			[Sys_DeleteType], 
			[Sys_IsDeleted], 
			[Sys_OrganizationID], 
			[Sys_InitialPrimaryKeys], 
			[Sys_WorkstationName] 
    FROM 
			[ProjectMemberMaster] 
    WHERE 
		( 
			[Sys_IsDeleted] = ISNULL(@Sys_IsDeleted, [Sys_IsDeleted]) AND
			[Sys_OrganizationID] = ISNULL(@Sys_OrganizationID, [Sys_OrganizationID]) 
		); 

END 
GO 

-- =================================END=====================================

